﻿//********************************************************************************//
//创建日期：<创建日期，2010-08-02>
//创建作者：<王一飞，wangyifei@shanghai3h.com>
//功能说明：QS_SLPCSJ1实体层次
//********************************************************************************//

#region Entity

using System;
using System.Data;
using Entity;
using Oracle.DataAccess.Client;
using Platform.Configuration;
using Platform.Data;

namespace Entity
{
    [Serializable]
    public class QS_SLPCSJ1
    {
        private double? m_db_n_guangaimj;

        private double? m_db_n_kuangqumj;

        private double? m_db_n_shijiggmj;

        private decimal? m_dec_i_chengjsj;

        private decimal? m_dec_i_d1;

        private decimal? m_dec_i_d2;

        private decimal? m_dec_i_d3;

        private decimal? m_dec_i_dixiams;

        private decimal? m_dec_i_gonglv;

        private decimal? m_dec_i_gongshuirk;

        private decimal? m_dec_i_jingnj;

        private decimal? m_dec_i_jingshen;

        private decimal? m_dec_i_liuliang;

        private decimal? m_dec_i_m1;

        private decimal? m_dec_i_m2;

        private decimal? m_dec_i_m3;

        private decimal? m_dec_i_y1;

        private decimal? m_dec_i_y2;

        private decimal? m_dec_i_y3;

        private decimal? m_dec_i_yangcheng;

        private decimal m_dec_id;

        private string m_str_s_bianhao;

        private string m_str_s_bw1;

        private string m_str_s_bw2;

        private string m_str_s_bw3;

        private string m_str_s_ckxkzzh;

        private string m_str_s_cslfqsl;

        private string m_str_s_dianhu3;

        private string m_str_s_dianhua1;

        private string m_str_s_dianhua2;

        private string m_str_s_dimaolx;

        private string m_str_s_dixiaslx;

        private string m_str_s_dj1;

        private string m_str_s_dj2;

        private string m_str_s_dj3;

        private string m_str_s_dwhdldqsl;

        private string m_str_s_dwhyldqsl;

        private string m_str_s_fuher;

        private string m_str_s_gldwlsgx;

        private string m_str_s_guanlidwmc;

        private string m_str_s_guanqulx;

        private string m_str_s_hdlfqsl;

        private string m_str_s_hylfqsl;

        private string m_str_s_jie;

        private string m_str_s_jiliangsslx;

        private string m_str_s_jingbicl;

        private string m_str_s_jutiwz;

        private string m_str_s_mingcheng;

        private string m_str_s_nxkqsl;

        private string m_str_s_qnhdl;

        private string m_str_s_qnhyl;

        private string m_str_s_qnkbss;

        private string m_str_s_qslqdff;

        private string m_str_s_qsxkzbh;

        private string m_str_s_qushuiyt;

        private string m_str_s_qushuiytxy;

        private string m_str_s_sbdwsjcsl;

        private string m_str_s_sfwdwzbj;

        private string m_str_s_sfwgmjdj;

        private string m_str_s_sfyazsljlss;

        private string m_str_s_sfyblckxkz;

        private string m_str_s_sfyblqsxkz;

        private string m_str_s_sfypdjdsb;

        private string m_str_s_shangbaodw;

        private string m_str_s_shenchar;

        private string m_str_s_sheng;

        private string m_str_s_shengchangm;

        private string m_str_s_shuibengxh;

        private string m_str_s_shuiwen;

        private string m_str_s_shuiyuandbm;

        private string m_str_s_shuiyuandmc;

        private string m_str_s_shuiyuanlx;

        private string m_str_s_sijiqbm;

        private string m_str_s_sijiqmc;

        private string m_str_s_sjfqsl;

        private string m_str_s_tianbiaor;

        private string m_str_s_xian;

        private string m_str_s_yingyongzk;

        private string m_str_s_zhen;

        private string m_str_s_zuobiao_x;

        private string m_str_s_zuobiao_y;

        /// <summary>
        ///     主键
        /// </summary>
        public decimal ID
        {
            get { return m_dec_id; }
            set { m_dec_id = value; }
        }

        /// <summary>
        ///     名称
        /// </summary>
        public string S_MINGCHENG
        {
            get { return m_str_s_mingcheng; }
            set { m_str_s_mingcheng = value; }
        }

        /// <summary>
        ///     编码
        /// </summary>
        public string S_BIANHAO
        {
            get { return m_str_s_bianhao; }
            set { m_str_s_bianhao = value; }
        }

        /// <summary>
        ///     省
        /// </summary>
        public string S_SHENG
        {
            get { return m_str_s_sheng; }
            set { m_str_s_sheng = value; }
        }

        /// <summary>
        ///     县
        /// </summary>
        public string S_XIAN
        {
            get { return m_str_s_xian; }
            set { m_str_s_xian = value; }
        }

        /// <summary>
        ///     镇
        /// </summary>
        public string S_ZHEN
        {
            get { return m_str_s_zhen; }
            set { m_str_s_zhen = value; }
        }

        /// <summary>
        ///     街/村
        /// </summary>
        public string S_JIE
        {
            get { return m_str_s_jie; }
            set { m_str_s_jie = value; }
        }

        /// <summary>
        ///     具体位置
        /// </summary>
        public string S_JUTIWZ
        {
            get { return m_str_s_jutiwz; }
            set { m_str_s_jutiwz = value; }
        }

        /// <summary>
        ///     东经1
        /// </summary>
        public string S_DJ1
        {
            get { return m_str_s_dj1; }
            set { m_str_s_dj1 = value; }
        }

        /// <summary>
        ///     东经2
        /// </summary>
        public string S_DJ2
        {
            get { return m_str_s_dj2; }
            set { m_str_s_dj2 = value; }
        }

        /// <summary>
        ///     东经3
        /// </summary>
        public string S_DJ3
        {
            get { return m_str_s_dj3; }
            set { m_str_s_dj3 = value; }
        }

        /// <summary>
        ///     北纬1
        /// </summary>
        public string S_BW1
        {
            get { return m_str_s_bw1; }
            set { m_str_s_bw1 = value; }
        }

        /// <summary>
        ///     北纬2
        /// </summary>
        public string S_BW2
        {
            get { return m_str_s_bw2; }
            set { m_str_s_bw2 = value; }
        }

        /// <summary>
        ///     北纬3
        /// </summary>
        public string S_BW3
        {
            get { return m_str_s_bw3; }
            set { m_str_s_bw3 = value; }
        }

        /// <summary>
        ///     x坐标
        /// </summary>
        public string S_ZUOBIAO_X
        {
            get { return m_str_s_zuobiao_x; }
            set { m_str_s_zuobiao_x = value; }
        }

        /// <summary>
        ///     y坐标
        /// </summary>
        public string S_ZUOBIAO_Y
        {
            get { return m_str_s_zuobiao_y; }
            set { m_str_s_zuobiao_y = value; }
        }

        /// <summary>
        ///     成井时间
        /// </summary>
        public decimal? I_CHENGJSJ
        {
            get { return m_dec_i_chengjsj; }
            set { m_dec_i_chengjsj = value; }
        }

        /// <summary>
        ///     井深
        /// </summary>
        public decimal? I_JINGSHEN
        {
            get { return m_dec_i_jingshen; }
            set { m_dec_i_jingshen = value; }
        }

        /// <summary>
        ///     地下埋深
        /// </summary>
        public decimal? I_DIXIAMS
        {
            get { return m_dec_i_dixiams; }
            set { m_dec_i_dixiams = value; }
        }

        /// <summary>
        ///     是否为单位自备井
        /// </summary>
        public string S_SFWDWZBJ
        {
            get { return m_str_s_sfwdwzbj; }
            set { m_str_s_sfwdwzbj = value; }
        }

        /// <summary>
        ///     井内径
        /// </summary>
        public decimal? I_JINGNJ
        {
            get { return m_dec_i_jingnj; }
            set { m_dec_i_jingnj = value; }
        }

        /// <summary>
        ///     井壁材料
        /// </summary>
        public string S_JINGBICL
        {
            get { return m_str_s_jingbicl; }
            set { m_str_s_jingbicl = value; }
        }

        /// <summary>
        ///     应用状况
        /// </summary>
        public string S_YINGYONGZK
        {
            get { return m_str_s_yingyongzk; }
            set { m_str_s_yingyongzk = value; }
        }

        /// <summary>
        ///     是否已配套机电设备
        /// </summary>
        public string S_SFYPDJDSB
        {
            get { return m_str_s_sfypdjdsb; }
            set { m_str_s_sfypdjdsb = value; }
        }

        /// <summary>
        ///     水泵型号
        /// </summary>
        public string S_SHUIBENGXH
        {
            get { return m_str_s_shuibengxh; }
            set { m_str_s_shuibengxh = value; }
        }

        /// <summary>
        ///     水泵额定扬程
        /// </summary>
        public decimal? I_YANGCHENG
        {
            get { return m_dec_i_yangcheng; }
            set { m_dec_i_yangcheng = value; }
        }

        /// <summary>
        ///     水泵额定流量
        /// </summary>
        public decimal? I_LIULIANG
        {
            get { return m_dec_i_liuliang; }
            set { m_dec_i_liuliang = value; }
        }

        /// <summary>
        ///     水泵额定功率
        /// </summary>
        public decimal? I_GONGLV
        {
            get { return m_dec_i_gonglv; }
            set { m_dec_i_gonglv = value; }
        }

        /// <summary>
        ///     是否已安装水量计量设施
        /// </summary>
        public string S_SFYAZSLJLSS
        {
            get { return m_str_s_sfyazsljlss; }
            set { m_str_s_sfyazsljlss = value; }
        }

        /// <summary>
        ///     水量计量设施类型
        /// </summary>
        public string S_JILIANGSSLX
        {
            get { return m_str_s_jiliangsslx; }
            set { m_str_s_jiliangsslx = value; }
        }

        /// <summary>
        ///     是否为规模以上地下水水源地的机电井
        /// </summary>
        public string S_SFWGMJDJ
        {
            get { return m_str_s_sfwgmjdj; }
            set { m_str_s_sfwgmjdj = value; }
        }

        /// <summary>
        ///     所在水源地名称
        /// </summary>
        public string S_SHUIYUANDMC
        {
            get { return m_str_s_shuiyuandmc; }
            set { m_str_s_shuiyuandmc = value; }
        }

        /// <summary>
        ///     所在水源地编码
        /// </summary>
        public string S_SHUIYUANDBM
        {
            get { return m_str_s_shuiyuandbm; }
            set { m_str_s_shuiyuandbm = value; }
        }

        /// <summary>
        ///     所在地貌类型区
        /// </summary>
        public string S_DIMAOLX
        {
            get { return m_str_s_dimaolx; }
            set { m_str_s_dimaolx = value; }
        }

        /// <summary>
        ///     所取用地下水的类型
        /// </summary>
        public string S_DIXIASLX
        {
            get { return m_str_s_dixiaslx; }
            set { m_str_s_dixiaslx = value; }
        }

        /// <summary>
        ///     所在水资源四级区名称
        /// </summary>
        public string S_SIJIQMC
        {
            get { return m_str_s_sijiqmc; }
            set { m_str_s_sijiqmc = value; }
        }

        /// <summary>
        ///     所在水资源四级区编码
        /// </summary>
        public string S_SIJIQBM
        {
            get { return m_str_s_sijiqbm; }
            set { m_str_s_sijiqbm = value; }
        }

        /// <summary>
        ///     水源类型
        /// </summary>
        public string S_SHUIYUANLX
        {
            get { return m_str_s_shuiyuanlx; }
            set { m_str_s_shuiyuanlx = value; }
        }

        /// <summary>
        ///     主要取水用途及效益
        /// </summary>
        public string S_QUSHUIYTXY
        {
            get { return m_str_s_qushuiytxy; }
            set { m_str_s_qushuiytxy = value; }
        }

        /// <summary>
        ///     乡村实际供水人口
        /// </summary>
        public decimal? I_GONGSHUIRK
        {
            get { return m_dec_i_gongshuirk; }
            set { m_dec_i_gongshuirk = value; }
        }

        /// <summary>
        ///     所在灌区类型
        /// </summary>
        public string S_GUANQULX
        {
            get { return m_str_s_guanqulx; }
            set { m_str_s_guanqulx = value; }
        }

        /// <summary>
        ///     控制灌溉面积
        /// </summary>
        public double? N_GUANGAIMJ
        {
            get { return m_db_n_guangaimj; }
            set { m_db_n_guangaimj = value; }
        }

        /// <summary>
        ///     实际灌溉面积
        /// </summary>
        public double? N_SHIJIGGMJ
        {
            get { return m_db_n_shijiggmj; }
            set { m_db_n_shijiggmj = value; }
        }

        /// <summary>
        ///     主要取水用途
        /// </summary>
        public string S_QUSHUIYT
        {
            get { return m_str_s_qushuiyt; }
            set { m_str_s_qushuiyt = value; }
        }

        /// <summary>
        ///     水温
        /// </summary>
        public string S_SHUIWEN
        {
            get { return m_str_s_shuiwen; }
            set { m_str_s_shuiwen = value; }
        }

        /// <summary>
        ///     取水量确定方法
        /// </summary>
        public string S_QSLQDFF
        {
            get { return m_str_s_qslqdff; }
            set { m_str_s_qslqdff = value; }
        }

        /// <summary>
        ///     全年耗电量
        /// </summary>
        public string S_QNHDL
        {
            get { return m_str_s_qnhdl; }
            set { m_str_s_qnhdl = value; }
        }

        /// <summary>
        ///     全年耗油量
        /// </summary>
        public string S_QNHYL
        {
            get { return m_str_s_qnhyl; }
            set { m_str_s_qnhyl = value; }
        }

        /// <summary>
        ///     全年开泵时数
        /// </summary>
        public string S_QNKBSS
        {
            get { return m_str_s_qnkbss; }
            set { m_str_s_qnkbss = value; }
        }

        /// <summary>
        ///     单位耗电量的取水量
        /// </summary>
        public string S_DWHDLDQSL
        {
            get { return m_str_s_dwhdldqsl; }
            set { m_str_s_dwhdldqsl = value; }
        }

        /// <summary>
        ///     单位耗油量的取水量
        /// </summary>
        public string S_DWHYLDQSL
        {
            get { return m_str_s_dwhyldqsl; }
            set { m_str_s_dwhyldqsl = value; }
        }

        /// <summary>
        ///     水泵单位时间出水量
        /// </summary>
        public string S_SBDWSJCSL
        {
            get { return m_str_s_sbdwsjcsl; }
            set { m_str_s_sbdwsjcsl = value; }
        }

        /// <summary>
        ///     实测法取水量
        /// </summary>
        public string S_SJFQSL
        {
            get { return m_str_s_sjfqsl; }
            set { m_str_s_sjfqsl = value; }
        }

        /// <summary>
        ///     耗电量法取水量
        /// </summary>
        public string S_HDLFQSL
        {
            get { return m_str_s_hdlfqsl; }
            set { m_str_s_hdlfqsl = value; }
        }

        /// <summary>
        ///     耗油量法取水量
        /// </summary>
        public string S_HYLFQSL
        {
            get { return m_str_s_hylfqsl; }
            set { m_str_s_hylfqsl = value; }
        }

        /// <summary>
        ///     出水量法取水量
        /// </summary>
        public string S_CSLFQSL
        {
            get { return m_str_s_cslfqsl; }
            set { m_str_s_cslfqsl = value; }
        }

        /// <summary>
        ///     是否已办理取水许可证
        /// </summary>
        public string S_SFYBLQSXKZ
        {
            get { return m_str_s_sfyblqsxkz; }
            set { m_str_s_sfyblqsxkz = value; }
        }

        /// <summary>
        ///     取水许可证编号
        /// </summary>
        public string S_QSXKZBH
        {
            get { return m_str_s_qsxkzbh; }
            set { m_str_s_qsxkzbh = value; }
        }

        /// <summary>
        ///     年许可取水量
        /// </summary>
        public string S_NXKQSL
        {
            get { return m_str_s_nxkqsl; }
            set { m_str_s_nxkqsl = value; }
        }

        /// <summary>
        ///     是否已办理采矿许可证
        /// </summary>
        public string S_SFYBLCKXKZ
        {
            get { return m_str_s_sfyblckxkz; }
            set { m_str_s_sfyblckxkz = value; }
        }

        /// <summary>
        ///     采矿许可证证号
        /// </summary>
        public string S_CKXKZZH
        {
            get { return m_str_s_ckxkzzh; }
            set { m_str_s_ckxkzzh = value; }
        }

        /// <summary>
        ///     矿区面积
        /// </summary>
        public double? N_KUANGQUMJ
        {
            get { return m_db_n_kuangqumj; }
            set { m_db_n_kuangqumj = value; }
        }

        /// <summary>
        ///     生产规模
        /// </summary>
        public string S_SHENGCHANGM
        {
            get { return m_str_s_shengchangm; }
            set { m_str_s_shengchangm = value; }
        }

        /// <summary>
        ///     管理单位名称
        /// </summary>
        public string S_GUANLIDWMC
        {
            get { return m_str_s_guanlidwmc; }
            set { m_str_s_guanlidwmc = value; }
        }

        /// <summary>
        ///     管理单位隶属关系
        /// </summary>
        public string S_GLDWLSGX
        {
            get { return m_str_s_gldwlsgx; }
            set { m_str_s_gldwlsgx = value; }
        }

        /// <summary>
        ///     填表人
        /// </summary>
        public string S_TIANBIAOR
        {
            get { return m_str_s_tianbiaor; }
            set { m_str_s_tianbiaor = value; }
        }

        /// <summary>
        ///     电话1
        /// </summary>
        public string S_DIANHUA1
        {
            get { return m_str_s_dianhua1; }
            set { m_str_s_dianhua1 = value; }
        }

        /// <summary>
        ///     年
        /// </summary>
        public decimal? I_Y1
        {
            get { return m_dec_i_y1; }
            set { m_dec_i_y1 = value; }
        }

        /// <summary>
        ///     月
        /// </summary>
        public decimal? I_M1
        {
            get { return m_dec_i_m1; }
            set { m_dec_i_m1 = value; }
        }

        /// <summary>
        ///     日
        /// </summary>
        public decimal? I_D1
        {
            get { return m_dec_i_d1; }
            set { m_dec_i_d1 = value; }
        }

        /// <summary>
        ///     复核人
        /// </summary>
        public string S_FUHER
        {
            get { return m_str_s_fuher; }
            set { m_str_s_fuher = value; }
        }

        /// <summary>
        ///     电话2
        /// </summary>
        public string S_DIANHUA2
        {
            get { return m_str_s_dianhua2; }
            set { m_str_s_dianhua2 = value; }
        }

        /// <summary>
        ///     年
        /// </summary>
        public decimal? I_Y2
        {
            get { return m_dec_i_y2; }
            set { m_dec_i_y2 = value; }
        }

        /// <summary>
        ///     月
        /// </summary>
        public decimal? I_M2
        {
            get { return m_dec_i_m2; }
            set { m_dec_i_m2 = value; }
        }

        /// <summary>
        ///     日
        /// </summary>
        public decimal? I_D2
        {
            get { return m_dec_i_d2; }
            set { m_dec_i_d2 = value; }
        }

        /// <summary>
        ///     审查人
        /// </summary>
        public string S_SHENCHAR
        {
            get { return m_str_s_shenchar; }
            set { m_str_s_shenchar = value; }
        }

        /// <summary>
        ///     电话3
        /// </summary>
        public string S_DIANHU3
        {
            get { return m_str_s_dianhu3; }
            set { m_str_s_dianhu3 = value; }
        }

        /// <summary>
        ///     年
        /// </summary>
        public decimal? I_Y3
        {
            get { return m_dec_i_y3; }
            set { m_dec_i_y3 = value; }
        }

        /// <summary>
        ///     月
        /// </summary>
        public decimal? I_M3
        {
            get { return m_dec_i_m3; }
            set { m_dec_i_m3 = value; }
        }

        /// <summary>
        ///     日
        /// </summary>
        public decimal? I_D3
        {
            get { return m_dec_i_d3; }
            set { m_dec_i_d3 = value; }
        }

        /// <summary>
        ///     上报单位
        /// </summary>
        public string S_SHANGBAODW
        {
            get { return m_str_s_shangbaodw; }
            set { m_str_s_shangbaodw = value; }
        }
    }
}

#endregion

#region EntityProcess

namespace BLL.Access
{
    //using System.Data.OracleClient;

    public class QS_SLPCSJ1Process
    {
        #region Field

        protected string conn;

        #endregion

        #region Construction

        public QS_SLPCSJ1Process()
        {
            conn = ConfigHelper.PlatformConnString;
        }

        #endregion

        #region public

        /// <summary>
        ///     根据QS_SLPCSJ1实体添加或者修改QS_SLPCSJ1信息
        /// </summary>
        public bool InsertOrUpdate(QS_SLPCSJ1 QS_SLPCSJ1, OracleTransaction Transaction)
        {
            if (QS_SLPCSJ1.ID == 0)
                InsertQS_SLPCSJ1(QS_SLPCSJ1, Transaction);
            else
                UpdateQS_SLPCSJ1(QS_SLPCSJ1, Transaction);
            return QS_SLPCSJ1.ID == 0 ? false : true;
        }

        /// <summary>
        ///     根据QS_SLPCSJ1实体添加或修改QS_SLPCSJ1信息
        /// </summary>
        public bool InsertOrUpdate(QS_SLPCSJ1 QS_SLPCSJ1)
        {
            return InsertOrUpdate(QS_SLPCSJ1, null);
        }


        /// <summary>
        ///     根据QS_SLPCSJ1主键删除QS_SLPCSJ1信息
        /// </summary>
        /// <param name="ID"></param>
        public bool DeleteQS_SLPCSJ1(decimal ID, OracleTransaction Transaction)
        {
            var spName = "CS_DelQS_SLPCSJ1";
            var storedParams = OracleHelperParameterCache.GetSpParameterSet(conn, spName);
            storedParams[0].Value = ID;
            var result = 0;
            if (Transaction == null)
                result = OracleHelper.ExecuteNonQuery(conn, CommandType.StoredProcedure, spName, storedParams);
            else
                result = OracleHelper.ExecuteNonQuery(Transaction, CommandType.StoredProcedure, spName, storedParams);
            return result == 0 ? false : true;
        }

        /// <summary>
        ///     根据QS_SLPCSJ1主键删除QS_SLPCSJ1信息
        /// </summary>
        /// <param name="ID"></param>
        public bool DeleteQS_SLPCSJ1(decimal ID)
        {
            return DeleteQS_SLPCSJ1(ID, null);
        }

        /// <summary>
        ///     根据条件删除QS_SLPCSJ1信息
        /// </summary>
        /// <param name="WhereClause">条件子句(Oracle语句)不带where</param>
        /// <param name="Transaction">事务，如果为null,则不做事务</param>
        /// <returns>如果删除成功，返回true,否则返回fals</returns>
        public bool DeleteQS_SLPCSJ1sDynamic(string WhereClause, OracleTransaction Transaction)
        {
            var spName = "CS_DelQS_SLPCSJ1sDyn";
            var storedParams = OracleHelperParameterCache.GetSpParameterSet(conn, spName);
            storedParams[0].Value = WhereClause;
            var result = 0;
            if (Transaction == null)
                result = OracleHelper.ExecuteNonQuery(conn, CommandType.StoredProcedure, spName, storedParams);
            else
                result = OracleHelper.ExecuteNonQuery(Transaction, CommandType.StoredProcedure, spName, storedParams);
            return result == 0 ? false : true;
        }

        /// <summary>
        ///     根据条件删除QS_SLPCSJ1信息
        /// </summary>
        /// <param name="WhereClause">条件子句(Oracle语句)不带where</param>
        /// <param name="Transaction">事务，如果为null,则不做事务</param>
        /// <returns>如果删除成功，返回true,否则返回fals</returns>
        public bool DeleteQS_SLPCSJ1sDynamic(string WhereClause)
        {
            return DeleteQS_SLPCSJ1sDynamic(WhereClause, null);
        }

        /// <summary>
        ///     根据QS_SLPCSJ1主键选择QS_SLPCSJ1信息
        /// </summary>
        /// <param name="Transaction">事务，如果为null,则不做事务</param>
        /// <returns>QS_SLPCSJ1信息</returns>
        public QS_SLPCSJ1 SelectQS_SLPCSJ1(decimal ID, OracleTransaction Transaction)
        {
            var spName = "CS_SelQS_SLPCSJ1";
            var storedParams = OracleHelperParameterCache.GetSpParameterSet(conn, spName);
            storedParams[0].Value = ID;
            OracleDataReader rd;
            if (Transaction == null)
                rd = OracleHelper.ExecuteReader(conn, CommandType.StoredProcedure, spName, storedParams);
            else
                rd = OracleHelper.ExecuteReader(Transaction, CommandType.StoredProcedure, spName, storedParams);
            if (rd.Read())
            {
                var QS_SLPCSJ1 = PopulateQS_SLPCSJ1(rd);
                rd.Close();
                return QS_SLPCSJ1;
            }
            return null;
        }

        /// <summary>
        ///     根据QS_SLPCSJ1主键选择QS_SLPCSJ1信息
        /// </summary>
        /// <returns>QS_SLPCSJ1信息</returns>
        public QS_SLPCSJ1 SelectQS_SLPCSJ1(decimal ID)
        {
            return SelectQS_SLPCSJ1(ID, null);
        }

        /// <summary>
        ///     选择所有QS_SLPCSJ1信息
        /// </summary>
        /// <param name="Transaction">事务，如果为null,则不做事务</param>
        /// <returns>所有QS_SLPCSJ1信息</returns>
        public DataTable SelectQS_SLPCSJ1sAll(OracleTransaction Transaction)
        {
            var spName = "CS_SelQS_SLPCSJ1sAll";
            var storedParams = OracleHelperParameterCache.GetSpParameterSet(conn, spName);
            DataSet ds = null;
            if (Transaction == null)
                ds = OracleHelper.ExecuteDataset(conn, CommandType.StoredProcedure, spName, storedParams);
            else
                ds = OracleHelper.ExecuteDataset(Transaction, CommandType.StoredProcedure, spName, storedParams);
            if (ds != null && ds.Tables.Count > 0)
            {
                AddRowNumber(ds.Tables[0]);
                return ds.Tables[0];
            }
            return null;
        }

        /// <summary>
        ///     选择所有QS_SLPCSJ1信息
        /// </summary>
        /// <returns>所有QS_SLPCSJ1信息</returns>
        public DataTable SelectQS_SLPCSJ1sAll()
        {
            return SelectQS_SLPCSJ1sAll(null);
        }

        /// <summary>
        ///     根据条件选择QS_SLPCSJ1信息
        /// </summary>
        /// <param name="WhereClause">条件子句(不带where)</param>
        /// <param name="OrderByExpression">排序子句</param>
        /// <param name="Transaction">事务，如果为null,则不做事务</param>
        /// <returns>QS_SLPCSJ1信息</returns>
        public DataTable SelectQS_SLPCSJ1sDynamic(string WhereClause, string OrderByExpression,
            OracleTransaction Transaction)
        {
            var spName = "CS_SelQS_SLPCSJ1sDyn";
            var storedParams = OracleHelperParameterCache.GetSpParameterSet(conn, spName);
            storedParams[0].Value = string.IsNullOrEmpty(WhereClause.Trim()) ? "1=1" : WhereClause;
            storedParams[1].Value = OrderByExpression;
            DataSet ds = null;
            if (Transaction == null)
                ds = OracleHelper.ExecuteDataset(conn, CommandType.StoredProcedure, spName, storedParams);
            else
                ds = OracleHelper.ExecuteDataset(Transaction, CommandType.StoredProcedure, spName, storedParams);
            if (ds != null && ds.Tables.Count > 0)
            {
                AddRowNumber(ds.Tables[0]);
                return ds.Tables[0];
            }
            return null;
        }


        /// <summary>
        ///     根据条件选择QS_SLPCSJ1信息
        /// </summary>
        /// <param name="WhereClause">条件子句(不带where)</param>
        /// <param name="OrderByExpression">排序子句</param>
        /// <returns>QS_SLPCSJ1信息</returns>
        public DataTable SelectQS_SLPCSJ1sDynamic(string WhereClause, string OrderByExpression)
        {
            return SelectQS_SLPCSJ1sDynamic(WhereClause, OrderByExpression, null);
        }


        /// <summary>
        ///     根据条件选择QS_SLPCSJ1信息
        /// </summary>
        /// <param name="WhereClause">条件子句(不带where)</param>
        /// <param name="OrderByExpression">排序子句</param>
        /// <param name="PageIndex">页码</param>
        /// <param name="PageSize">页数</param>
        /// <param name="Transaction">事务，如果为null,则不做事务</param>
        /// <returns>QS_SLPCSJ1信息</returns>
        public DataTable SelectQS_SLPCSJ1sDynamic(string WhereClause, string OrderByExpression, int PageIndex,
            int PageSize, OracleTransaction Transaction)
        {
            var spName = "CS_SelQS_SLPCSJ1sDynPaged";
            var storedParams = OracleHelperParameterCache.GetSpParameterSet(conn, spName);
            storedParams[0].Value = string.IsNullOrEmpty(WhereClause.Trim()) ? "1=1" : WhereClause;
            storedParams[1].Value = OrderByExpression;
            storedParams[2].Value = PageIndex;
            storedParams[3].Value = PageSize;
            DataSet ds = null;
            if (Transaction == null)
                ds = OracleHelper.ExecuteDataset(conn, CommandType.StoredProcedure, spName, storedParams);
            else
                ds = OracleHelper.ExecuteDataset(Transaction, CommandType.StoredProcedure, spName, storedParams);
            if (ds != null && ds.Tables.Count > 0)
            {
                AddRowNumber(ds.Tables[0]);
                return ds.Tables[0];
            }
            return null;
        }


        /// <summary>
        ///     根据条件选择QS_SLPCSJ1信息
        /// </summary>
        /// <param name="WhereClause">条件子句(不带where)</param>
        /// <param name="OrderByExpression">排序子句</param>
        /// <param name="PageIndex">页码</param>
        /// <param name="PageSize">页数</param>
        /// <returns>QS_SLPCSJ1信息</returns>
        public DataTable SelectQS_SLPCSJ1sDynamic(string WhereClause, string OrderByExpression, int PageIndex,
            int PageSize)
        {
            return SelectQS_SLPCSJ1sDynamic(WhereClause, OrderByExpression, PageIndex, PageSize, null);
        }

        /// <summary>
        ///     根据条件更新QS_SLPCSJ1字段
        /// </summary>
        /// <returns>受影响行数</returns>
        public int UpdateQS_SLPCSJ1sDynamic(string UpdateValue, string WhereClause, OracleTransaction Transaction)
        {
            var result = 0;
            if (UpdateValue == "" || WhereClause == "")
                return 0;
            var spName = "CS_UpdQS_SLPCSJ1Dyn";
            var storedParams = OracleHelperParameterCache.GetSpParameterSet(conn, spName);
            DataSet ds = null;
            storedParams[0].Value = UpdateValue;
            storedParams[1].Value = WhereClause;
            if (Transaction == null)
                ds = OracleHelper.ExecuteDataset(conn, CommandType.StoredProcedure, spName, storedParams);
            else
                ds = OracleHelper.ExecuteDataset(Transaction, CommandType.StoredProcedure, spName, storedParams);
            result = Convert.ToInt32(storedParams[2].Value);
            return result;
        }

        /// <summary>
        ///     根据条件更新QS_SLPCSJ1字段
        /// </summary>
        /// <returns>受影响行数</returns>
        public int UpdateQS_SLPCSJ1sDynamic(string UpdateValue, string WhereClause)
        {
            return UpdateQS_SLPCSJ1sDynamic(UpdateValue, WhereClause, null);
        }

        #endregion

        #region Private

        private int InsertQS_SLPCSJ1(QS_SLPCSJ1 QS_SLPCSJ1, OracleTransaction Transaction)
        {
            var spName = "CS_InsQS_SLPCSJ1";
            var storedParams = OracleHelperParameterCache.GetSpParameterSet(conn, spName);
            storedParams[0].Value = QS_SLPCSJ1.S_MINGCHENG;
            storedParams[1].Value = QS_SLPCSJ1.S_BIANHAO;
            storedParams[2].Value = QS_SLPCSJ1.S_SHENG;
            storedParams[3].Value = QS_SLPCSJ1.S_XIAN;
            storedParams[4].Value = QS_SLPCSJ1.S_ZHEN;
            storedParams[5].Value = QS_SLPCSJ1.S_JIE;
            storedParams[6].Value = QS_SLPCSJ1.S_JUTIWZ;
            storedParams[7].Value = QS_SLPCSJ1.S_DJ1;
            storedParams[8].Value = QS_SLPCSJ1.S_DJ2;
            storedParams[9].Value = QS_SLPCSJ1.S_DJ3;
            storedParams[10].Value = QS_SLPCSJ1.S_BW1;
            storedParams[11].Value = QS_SLPCSJ1.S_BW2;
            storedParams[12].Value = QS_SLPCSJ1.S_BW3;
            storedParams[13].Value = QS_SLPCSJ1.S_ZUOBIAO_X;
            storedParams[14].Value = QS_SLPCSJ1.S_ZUOBIAO_Y;
            storedParams[15].Value = QS_SLPCSJ1.I_CHENGJSJ;
            storedParams[16].Value = QS_SLPCSJ1.I_JINGSHEN;
            storedParams[17].Value = QS_SLPCSJ1.I_DIXIAMS;
            storedParams[18].Value = QS_SLPCSJ1.S_SFWDWZBJ;
            storedParams[19].Value = QS_SLPCSJ1.I_JINGNJ;
            storedParams[20].Value = QS_SLPCSJ1.S_JINGBICL;
            storedParams[21].Value = QS_SLPCSJ1.S_YINGYONGZK;
            storedParams[22].Value = QS_SLPCSJ1.S_SFYPDJDSB;
            storedParams[23].Value = QS_SLPCSJ1.S_SHUIBENGXH;
            storedParams[24].Value = QS_SLPCSJ1.I_YANGCHENG;
            storedParams[25].Value = QS_SLPCSJ1.I_LIULIANG;
            storedParams[26].Value = QS_SLPCSJ1.I_GONGLV;
            storedParams[27].Value = QS_SLPCSJ1.S_SFYAZSLJLSS;
            storedParams[28].Value = QS_SLPCSJ1.S_JILIANGSSLX;
            storedParams[29].Value = QS_SLPCSJ1.S_SFWGMJDJ;
            storedParams[30].Value = QS_SLPCSJ1.S_SHUIYUANDMC;
            storedParams[31].Value = QS_SLPCSJ1.S_SHUIYUANDBM;
            storedParams[32].Value = QS_SLPCSJ1.S_DIMAOLX;
            storedParams[33].Value = QS_SLPCSJ1.S_DIXIASLX;
            storedParams[34].Value = QS_SLPCSJ1.S_SIJIQMC;
            storedParams[35].Value = QS_SLPCSJ1.S_SIJIQBM;
            storedParams[36].Value = QS_SLPCSJ1.S_SHUIYUANLX;
            storedParams[37].Value = QS_SLPCSJ1.S_QUSHUIYTXY;
            storedParams[38].Value = QS_SLPCSJ1.I_GONGSHUIRK;
            storedParams[39].Value = QS_SLPCSJ1.S_GUANQULX;
            storedParams[40].Value = QS_SLPCSJ1.N_GUANGAIMJ;
            storedParams[41].Value = QS_SLPCSJ1.N_SHIJIGGMJ;
            storedParams[42].Value = QS_SLPCSJ1.S_QUSHUIYT;
            storedParams[43].Value = QS_SLPCSJ1.S_SHUIWEN;
            storedParams[44].Value = QS_SLPCSJ1.S_QSLQDFF;
            storedParams[45].Value = QS_SLPCSJ1.S_QNHDL;
            storedParams[46].Value = QS_SLPCSJ1.S_QNHYL;
            storedParams[47].Value = QS_SLPCSJ1.S_QNKBSS;
            storedParams[48].Value = QS_SLPCSJ1.S_DWHDLDQSL;
            storedParams[49].Value = QS_SLPCSJ1.S_DWHYLDQSL;
            storedParams[50].Value = QS_SLPCSJ1.S_SBDWSJCSL;
            storedParams[51].Value = QS_SLPCSJ1.S_SJFQSL;
            storedParams[52].Value = QS_SLPCSJ1.S_HDLFQSL;
            storedParams[53].Value = QS_SLPCSJ1.S_HYLFQSL;
            storedParams[54].Value = QS_SLPCSJ1.S_CSLFQSL;
            storedParams[55].Value = QS_SLPCSJ1.S_SFYBLQSXKZ;
            storedParams[56].Value = QS_SLPCSJ1.S_QSXKZBH;
            storedParams[57].Value = QS_SLPCSJ1.S_NXKQSL;
            storedParams[58].Value = QS_SLPCSJ1.S_SFYBLCKXKZ;
            storedParams[59].Value = QS_SLPCSJ1.S_CKXKZZH;
            storedParams[60].Value = QS_SLPCSJ1.N_KUANGQUMJ;
            storedParams[61].Value = QS_SLPCSJ1.S_SHENGCHANGM;
            storedParams[62].Value = QS_SLPCSJ1.S_GUANLIDWMC;
            storedParams[63].Value = QS_SLPCSJ1.S_GLDWLSGX;
            storedParams[64].Value = QS_SLPCSJ1.S_TIANBIAOR;
            storedParams[65].Value = QS_SLPCSJ1.S_DIANHUA1;
            storedParams[66].Value = QS_SLPCSJ1.I_Y1;
            storedParams[67].Value = QS_SLPCSJ1.I_M1;
            storedParams[68].Value = QS_SLPCSJ1.I_D1;
            storedParams[69].Value = QS_SLPCSJ1.S_FUHER;
            storedParams[70].Value = QS_SLPCSJ1.S_DIANHUA2;
            storedParams[71].Value = QS_SLPCSJ1.I_Y2;
            storedParams[72].Value = QS_SLPCSJ1.I_M2;
            storedParams[73].Value = QS_SLPCSJ1.I_D2;
            storedParams[74].Value = QS_SLPCSJ1.S_SHENCHAR;
            storedParams[75].Value = QS_SLPCSJ1.S_DIANHU3;
            storedParams[76].Value = QS_SLPCSJ1.I_Y3;
            storedParams[77].Value = QS_SLPCSJ1.I_M3;
            storedParams[78].Value = QS_SLPCSJ1.I_D3;
            storedParams[79].Value = QS_SLPCSJ1.S_SHANGBAODW;
            var result = 0;
            if (Transaction == null)
                result = OracleHelper.ExecuteNonQuery(conn, CommandType.StoredProcedure, spName, storedParams);
            else
                result = OracleHelper.ExecuteNonQuery(Transaction, CommandType.StoredProcedure, spName, storedParams);
            QS_SLPCSJ1.ID = Convert.ToInt32(storedParams[80].Value);
            return result;
        }

        private bool UpdateQS_SLPCSJ1(QS_SLPCSJ1 QS_SLPCSJ1, OracleTransaction Transaction)
        {
            var spName = "CS_UpdQS_SLPCSJ1";
            var storedParams = OracleHelperParameterCache.GetSpParameterSet(conn, spName);
            storedParams[0].Value = QS_SLPCSJ1.S_MINGCHENG;
            storedParams[1].Value = QS_SLPCSJ1.S_BIANHAO;
            storedParams[2].Value = QS_SLPCSJ1.S_SHENG;
            storedParams[3].Value = QS_SLPCSJ1.S_XIAN;
            storedParams[4].Value = QS_SLPCSJ1.S_ZHEN;
            storedParams[5].Value = QS_SLPCSJ1.S_JIE;
            storedParams[6].Value = QS_SLPCSJ1.S_JUTIWZ;
            storedParams[7].Value = QS_SLPCSJ1.S_DJ1;
            storedParams[8].Value = QS_SLPCSJ1.S_DJ2;
            storedParams[9].Value = QS_SLPCSJ1.S_DJ3;
            storedParams[10].Value = QS_SLPCSJ1.S_BW1;
            storedParams[11].Value = QS_SLPCSJ1.S_BW2;
            storedParams[12].Value = QS_SLPCSJ1.S_BW3;
            storedParams[13].Value = QS_SLPCSJ1.S_ZUOBIAO_X;
            storedParams[14].Value = QS_SLPCSJ1.S_ZUOBIAO_Y;
            storedParams[15].Value = QS_SLPCSJ1.I_CHENGJSJ;
            storedParams[16].Value = QS_SLPCSJ1.I_JINGSHEN;
            storedParams[17].Value = QS_SLPCSJ1.I_DIXIAMS;
            storedParams[18].Value = QS_SLPCSJ1.S_SFWDWZBJ;
            storedParams[19].Value = QS_SLPCSJ1.I_JINGNJ;
            storedParams[20].Value = QS_SLPCSJ1.S_JINGBICL;
            storedParams[21].Value = QS_SLPCSJ1.S_YINGYONGZK;
            storedParams[22].Value = QS_SLPCSJ1.S_SFYPDJDSB;
            storedParams[23].Value = QS_SLPCSJ1.S_SHUIBENGXH;
            storedParams[24].Value = QS_SLPCSJ1.I_YANGCHENG;
            storedParams[25].Value = QS_SLPCSJ1.I_LIULIANG;
            storedParams[26].Value = QS_SLPCSJ1.I_GONGLV;
            storedParams[27].Value = QS_SLPCSJ1.S_SFYAZSLJLSS;
            storedParams[28].Value = QS_SLPCSJ1.S_JILIANGSSLX;
            storedParams[29].Value = QS_SLPCSJ1.S_SFWGMJDJ;
            storedParams[30].Value = QS_SLPCSJ1.S_SHUIYUANDMC;
            storedParams[31].Value = QS_SLPCSJ1.S_SHUIYUANDBM;
            storedParams[32].Value = QS_SLPCSJ1.S_DIMAOLX;
            storedParams[33].Value = QS_SLPCSJ1.S_DIXIASLX;
            storedParams[34].Value = QS_SLPCSJ1.S_SIJIQMC;
            storedParams[35].Value = QS_SLPCSJ1.S_SIJIQBM;
            storedParams[36].Value = QS_SLPCSJ1.S_SHUIYUANLX;
            storedParams[37].Value = QS_SLPCSJ1.S_QUSHUIYTXY;
            storedParams[38].Value = QS_SLPCSJ1.I_GONGSHUIRK;
            storedParams[39].Value = QS_SLPCSJ1.S_GUANQULX;
            storedParams[40].Value = QS_SLPCSJ1.N_GUANGAIMJ;
            storedParams[41].Value = QS_SLPCSJ1.N_SHIJIGGMJ;
            storedParams[42].Value = QS_SLPCSJ1.S_QUSHUIYT;
            storedParams[43].Value = QS_SLPCSJ1.S_SHUIWEN;
            storedParams[44].Value = QS_SLPCSJ1.S_QSLQDFF;
            storedParams[45].Value = QS_SLPCSJ1.S_QNHDL;
            storedParams[46].Value = QS_SLPCSJ1.S_QNHYL;
            storedParams[47].Value = QS_SLPCSJ1.S_QNKBSS;
            storedParams[48].Value = QS_SLPCSJ1.S_DWHDLDQSL;
            storedParams[49].Value = QS_SLPCSJ1.S_DWHYLDQSL;
            storedParams[50].Value = QS_SLPCSJ1.S_SBDWSJCSL;
            storedParams[51].Value = QS_SLPCSJ1.S_SJFQSL;
            storedParams[52].Value = QS_SLPCSJ1.S_HDLFQSL;
            storedParams[53].Value = QS_SLPCSJ1.S_HYLFQSL;
            storedParams[54].Value = QS_SLPCSJ1.S_CSLFQSL;
            storedParams[55].Value = QS_SLPCSJ1.S_SFYBLQSXKZ;
            storedParams[56].Value = QS_SLPCSJ1.S_QSXKZBH;
            storedParams[57].Value = QS_SLPCSJ1.S_NXKQSL;
            storedParams[58].Value = QS_SLPCSJ1.S_SFYBLCKXKZ;
            storedParams[59].Value = QS_SLPCSJ1.S_CKXKZZH;
            storedParams[60].Value = QS_SLPCSJ1.N_KUANGQUMJ;
            storedParams[61].Value = QS_SLPCSJ1.S_SHENGCHANGM;
            storedParams[62].Value = QS_SLPCSJ1.S_GUANLIDWMC;
            storedParams[63].Value = QS_SLPCSJ1.S_GLDWLSGX;
            storedParams[64].Value = QS_SLPCSJ1.S_TIANBIAOR;
            storedParams[65].Value = QS_SLPCSJ1.S_DIANHUA1;
            storedParams[66].Value = QS_SLPCSJ1.I_Y1;
            storedParams[67].Value = QS_SLPCSJ1.I_M1;
            storedParams[68].Value = QS_SLPCSJ1.I_D1;
            storedParams[69].Value = QS_SLPCSJ1.S_FUHER;
            storedParams[70].Value = QS_SLPCSJ1.S_DIANHUA2;
            storedParams[71].Value = QS_SLPCSJ1.I_Y2;
            storedParams[72].Value = QS_SLPCSJ1.I_M2;
            storedParams[73].Value = QS_SLPCSJ1.I_D2;
            storedParams[74].Value = QS_SLPCSJ1.S_SHENCHAR;
            storedParams[75].Value = QS_SLPCSJ1.S_DIANHU3;
            storedParams[76].Value = QS_SLPCSJ1.I_Y3;
            storedParams[77].Value = QS_SLPCSJ1.I_M3;
            storedParams[78].Value = QS_SLPCSJ1.I_D3;
            storedParams[79].Value = QS_SLPCSJ1.S_SHANGBAODW;
            storedParams[80].Value = QS_SLPCSJ1.ID;
            var result = 0;
            if (Transaction == null)
                result = OracleHelper.ExecuteNonQuery(conn, CommandType.StoredProcedure, spName, storedParams);
            else
                result = OracleHelper.ExecuteNonQuery(Transaction, CommandType.StoredProcedure, spName, storedParams);
            return result == 0 ? false : true;
        }


        private QS_SLPCSJ1 PopulateQS_SLPCSJ1(IDataReader dr)
        {
            var QS_SLPCSJ1 = new QS_SLPCSJ1();
            QS_SLPCSJ1.ID = dr["ID"] == DBNull.Value ? 0 : (decimal) dr["ID"];
            QS_SLPCSJ1.S_MINGCHENG = dr["S_MINGCHENG"] == DBNull.Value ? null : (string) dr["S_MINGCHENG"];
            QS_SLPCSJ1.S_BIANHAO = dr["S_BIANHAO"] == DBNull.Value ? null : (string) dr["S_BIANHAO"];
            QS_SLPCSJ1.S_SHENG = dr["S_SHENG"] == DBNull.Value ? null : (string) dr["S_SHENG"];
            QS_SLPCSJ1.S_XIAN = dr["S_XIAN"] == DBNull.Value ? null : (string) dr["S_XIAN"];
            QS_SLPCSJ1.S_ZHEN = dr["S_ZHEN"] == DBNull.Value ? null : (string) dr["S_ZHEN"];
            QS_SLPCSJ1.S_JIE = dr["S_JIE"] == DBNull.Value ? null : (string) dr["S_JIE"];
            QS_SLPCSJ1.S_JUTIWZ = dr["S_JUTIWZ"] == DBNull.Value ? null : (string) dr["S_JUTIWZ"];
            QS_SLPCSJ1.S_DJ1 = dr["S_DJ1"] == DBNull.Value ? null : (string) dr["S_DJ1"];
            QS_SLPCSJ1.S_DJ2 = dr["S_DJ2"] == DBNull.Value ? null : (string) dr["S_DJ2"];
            QS_SLPCSJ1.S_DJ3 = dr["S_DJ3"] == DBNull.Value ? null : (string) dr["S_DJ3"];
            QS_SLPCSJ1.S_BW1 = dr["S_BW1"] == DBNull.Value ? null : (string) dr["S_BW1"];
            QS_SLPCSJ1.S_BW2 = dr["S_BW2"] == DBNull.Value ? null : (string) dr["S_BW2"];
            QS_SLPCSJ1.S_BW3 = dr["S_BW3"] == DBNull.Value ? null : (string) dr["S_BW3"];
            QS_SLPCSJ1.S_ZUOBIAO_X = dr["S_ZUOBIAO_X"] == DBNull.Value ? null : (string) dr["S_ZUOBIAO_X"];
            QS_SLPCSJ1.S_ZUOBIAO_Y = dr["S_ZUOBIAO_Y"] == DBNull.Value ? null : (string) dr["S_ZUOBIAO_Y"];
            QS_SLPCSJ1.I_CHENGJSJ = dr["I_CHENGJSJ"] == DBNull.Value ? null : (decimal?) dr["I_CHENGJSJ"];
            QS_SLPCSJ1.I_JINGSHEN = dr["I_JINGSHEN"] == DBNull.Value ? null : (decimal?) dr["I_JINGSHEN"];
            QS_SLPCSJ1.I_DIXIAMS = dr["I_DIXIAMS"] == DBNull.Value ? null : (decimal?) dr["I_DIXIAMS"];
            QS_SLPCSJ1.S_SFWDWZBJ = dr["S_SFWDWZBJ"] == DBNull.Value ? null : (string) dr["S_SFWDWZBJ"];
            QS_SLPCSJ1.I_JINGNJ = dr["I_JINGNJ"] == DBNull.Value ? null : (decimal?) dr["I_JINGNJ"];
            QS_SLPCSJ1.S_JINGBICL = dr["S_JINGBICL"] == DBNull.Value ? null : (string) dr["S_JINGBICL"];
            QS_SLPCSJ1.S_YINGYONGZK = dr["S_YINGYONGZK"] == DBNull.Value ? null : (string) dr["S_YINGYONGZK"];
            QS_SLPCSJ1.S_SFYPDJDSB = dr["S_SFYPDJDSB"] == DBNull.Value ? null : (string) dr["S_SFYPDJDSB"];
            QS_SLPCSJ1.S_SHUIBENGXH = dr["S_SHUIBENGXH"] == DBNull.Value ? null : (string) dr["S_SHUIBENGXH"];
            QS_SLPCSJ1.I_YANGCHENG = dr["I_YANGCHENG"] == DBNull.Value ? null : (decimal?) dr["I_YANGCHENG"];
            QS_SLPCSJ1.I_LIULIANG = dr["I_LIULIANG"] == DBNull.Value ? null : (decimal?) dr["I_LIULIANG"];
            QS_SLPCSJ1.I_GONGLV = dr["I_GONGLV"] == DBNull.Value ? null : (decimal?) dr["I_GONGLV"];
            QS_SLPCSJ1.S_SFYAZSLJLSS = dr["S_SFYAZSLJLSS"] == DBNull.Value ? null : (string) dr["S_SFYAZSLJLSS"];
            QS_SLPCSJ1.S_JILIANGSSLX = dr["S_JILIANGSSLX"] == DBNull.Value ? null : (string) dr["S_JILIANGSSLX"];
            QS_SLPCSJ1.S_SFWGMJDJ = dr["S_SFWGMJDJ"] == DBNull.Value ? null : (string) dr["S_SFWGMJDJ"];
            QS_SLPCSJ1.S_SHUIYUANDMC = dr["S_SHUIYUANDMC"] == DBNull.Value ? null : (string) dr["S_SHUIYUANDMC"];
            QS_SLPCSJ1.S_SHUIYUANDBM = dr["S_SHUIYUANDBM"] == DBNull.Value ? null : (string) dr["S_SHUIYUANDBM"];
            QS_SLPCSJ1.S_DIMAOLX = dr["S_DIMAOLX"] == DBNull.Value ? null : (string) dr["S_DIMAOLX"];
            QS_SLPCSJ1.S_DIXIASLX = dr["S_DIXIASLX"] == DBNull.Value ? null : (string) dr["S_DIXIASLX"];
            QS_SLPCSJ1.S_SIJIQMC = dr["S_SIJIQMC"] == DBNull.Value ? null : (string) dr["S_SIJIQMC"];
            QS_SLPCSJ1.S_SIJIQBM = dr["S_SIJIQBM"] == DBNull.Value ? null : (string) dr["S_SIJIQBM"];
            QS_SLPCSJ1.S_SHUIYUANLX = dr["S_SHUIYUANLX"] == DBNull.Value ? null : (string) dr["S_SHUIYUANLX"];
            QS_SLPCSJ1.S_QUSHUIYTXY = dr["S_QUSHUIYTXY"] == DBNull.Value ? null : (string) dr["S_QUSHUIYTXY"];
            QS_SLPCSJ1.I_GONGSHUIRK = dr["I_GONGSHUIRK"] == DBNull.Value ? null : (decimal?) dr["I_GONGSHUIRK"];
            QS_SLPCSJ1.S_GUANQULX = dr["S_GUANQULX"] == DBNull.Value ? null : (string) dr["S_GUANQULX"];
            QS_SLPCSJ1.N_GUANGAIMJ = dr["N_GUANGAIMJ"] == DBNull.Value ? null : (double?) dr["N_GUANGAIMJ"];
            QS_SLPCSJ1.N_SHIJIGGMJ = dr["N_SHIJIGGMJ"] == DBNull.Value ? null : (double?) dr["N_SHIJIGGMJ"];
            QS_SLPCSJ1.S_QUSHUIYT = dr["S_QUSHUIYT"] == DBNull.Value ? null : (string) dr["S_QUSHUIYT"];
            QS_SLPCSJ1.S_SHUIWEN = dr["S_SHUIWEN"] == DBNull.Value ? null : (string) dr["S_SHUIWEN"];
            QS_SLPCSJ1.S_QSLQDFF = dr["S_QSLQDFF"] == DBNull.Value ? null : (string) dr["S_QSLQDFF"];
            QS_SLPCSJ1.S_QNHDL = dr["S_QNHDL"] == DBNull.Value ? null : (string) dr["S_QNHDL"];
            QS_SLPCSJ1.S_QNHYL = dr["S_QNHYL"] == DBNull.Value ? null : (string) dr["S_QNHYL"];
            QS_SLPCSJ1.S_QNKBSS = dr["S_QNKBSS"] == DBNull.Value ? null : (string) dr["S_QNKBSS"];
            QS_SLPCSJ1.S_DWHDLDQSL = dr["S_DWHDLDQSL"] == DBNull.Value ? null : (string) dr["S_DWHDLDQSL"];
            QS_SLPCSJ1.S_DWHYLDQSL = dr["S_DWHYLDQSL"] == DBNull.Value ? null : (string) dr["S_DWHYLDQSL"];
            QS_SLPCSJ1.S_SBDWSJCSL = dr["S_SBDWSJCSL"] == DBNull.Value ? null : (string) dr["S_SBDWSJCSL"];
            QS_SLPCSJ1.S_SJFQSL = dr["S_SJFQSL"] == DBNull.Value ? null : (string) dr["S_SJFQSL"];
            QS_SLPCSJ1.S_HDLFQSL = dr["S_HDLFQSL"] == DBNull.Value ? null : (string) dr["S_HDLFQSL"];
            QS_SLPCSJ1.S_HYLFQSL = dr["S_HYLFQSL"] == DBNull.Value ? null : (string) dr["S_HYLFQSL"];
            QS_SLPCSJ1.S_CSLFQSL = dr["S_CSLFQSL"] == DBNull.Value ? null : (string) dr["S_CSLFQSL"];
            QS_SLPCSJ1.S_SFYBLQSXKZ = dr["S_SFYBLQSXKZ"] == DBNull.Value ? null : (string) dr["S_SFYBLQSXKZ"];
            QS_SLPCSJ1.S_QSXKZBH = dr["S_QSXKZBH"] == DBNull.Value ? null : (string) dr["S_QSXKZBH"];
            QS_SLPCSJ1.S_NXKQSL = dr["S_NXKQSL"] == DBNull.Value ? null : (string) dr["S_NXKQSL"];
            QS_SLPCSJ1.S_SFYBLCKXKZ = dr["S_SFYBLCKXKZ"] == DBNull.Value ? null : (string) dr["S_SFYBLCKXKZ"];
            QS_SLPCSJ1.S_CKXKZZH = dr["S_CKXKZZH"] == DBNull.Value ? null : (string) dr["S_CKXKZZH"];
            QS_SLPCSJ1.N_KUANGQUMJ = dr["N_KUANGQUMJ"] == DBNull.Value ? null : (double?) dr["N_KUANGQUMJ"];
            QS_SLPCSJ1.S_SHENGCHANGM = dr["S_SHENGCHANGM"] == DBNull.Value ? null : (string) dr["S_SHENGCHANGM"];
            QS_SLPCSJ1.S_GUANLIDWMC = dr["S_GUANLIDWMC"] == DBNull.Value ? null : (string) dr["S_GUANLIDWMC"];
            QS_SLPCSJ1.S_GLDWLSGX = dr["S_GLDWLSGX"] == DBNull.Value ? null : (string) dr["S_GLDWLSGX"];
            QS_SLPCSJ1.S_TIANBIAOR = dr["S_TIANBIAOR"] == DBNull.Value ? null : (string) dr["S_TIANBIAOR"];
            QS_SLPCSJ1.S_DIANHUA1 = dr["S_DIANHUA1"] == DBNull.Value ? null : (string) dr["S_DIANHUA1"];
            QS_SLPCSJ1.I_Y1 = dr["I_Y1"] == DBNull.Value ? null : (decimal?) dr["I_Y1"];
            QS_SLPCSJ1.I_M1 = dr["I_M1"] == DBNull.Value ? null : (decimal?) dr["I_M1"];
            QS_SLPCSJ1.I_D1 = dr["I_D1"] == DBNull.Value ? null : (decimal?) dr["I_D1"];
            QS_SLPCSJ1.S_FUHER = dr["S_FUHER"] == DBNull.Value ? null : (string) dr["S_FUHER"];
            QS_SLPCSJ1.S_DIANHUA2 = dr["S_DIANHUA2"] == DBNull.Value ? null : (string) dr["S_DIANHUA2"];
            QS_SLPCSJ1.I_Y2 = dr["I_Y2"] == DBNull.Value ? null : (decimal?) dr["I_Y2"];
            QS_SLPCSJ1.I_M2 = dr["I_M2"] == DBNull.Value ? null : (decimal?) dr["I_M2"];
            QS_SLPCSJ1.I_D2 = dr["I_D2"] == DBNull.Value ? null : (decimal?) dr["I_D2"];
            QS_SLPCSJ1.S_SHENCHAR = dr["S_SHENCHAR"] == DBNull.Value ? null : (string) dr["S_SHENCHAR"];
            QS_SLPCSJ1.S_DIANHU3 = dr["S_DIANHU3"] == DBNull.Value ? null : (string) dr["S_DIANHU3"];
            QS_SLPCSJ1.I_Y3 = dr["I_Y3"] == DBNull.Value ? null : (decimal?) dr["I_Y3"];
            QS_SLPCSJ1.I_M3 = dr["I_M3"] == DBNull.Value ? null : (decimal?) dr["I_M3"];
            QS_SLPCSJ1.I_D3 = dr["I_D3"] == DBNull.Value ? null : (decimal?) dr["I_D3"];
            QS_SLPCSJ1.S_SHANGBAODW = dr["S_SHANGBAODW"] == DBNull.Value ? null : (string) dr["S_SHANGBAODW"];
            return QS_SLPCSJ1;
        }


        private void AddRowNumber(DataTable dt)
        {
            dt.Columns.Add(new DataColumn("RowNumber", typeof(int)));
            for (var i = 0; i < dt.Rows.Count; i++)
                dt.Rows[i][dt.Columns.Count - 1] = i + 1;
        }

        #endregion
    }
}

#endregion